DETALLEREQUISICION

"192.168.0.1:sipop"

DETALLEREQUISICION

Descriptions

DETALLE DE REQUISICION DE MATERIALES

Fields

Name	Domain	Data type	Description
ID_DETALLE_REQ		CHAR (8)	ID de la tabla
ARTICULO		CHAR (8)	Id del producto solicitado
CANTIDAD		FLOAT	Cantidad de items
CODIGO_REQUISICION		CHAR (8)	ID del maestro en la tabla Requisicion
ITEM_ENTREGADO	BOOLEAN	VARCHAR (5)
ITEM_ANULADO	BOOLEAN	VARCHAR (5)

Triggers

Trigger	Type	Active	Position	Description
DETALLEREQUISICION_BI	Before Insert		0

Indices

Index	Fields	Active	Unique	Order
FK_DETALLEREQUISICION	CODIGO_REQUISICION			Ascending

References

Table	Foreign Key	Fields	FK Fields	DEL Rule	UPD Rule
REQUISICION	FK_DETALLEREQUISICION	CODIGO_REQUISICION	ID_REQUISICION	RESTRICT	RESTRICT
INVENTARIO	INTEG_251	ARTICULO	ID_ARTICULO	RESTRICT	RESTRICT

Referenced

There are no tables referenced by table DETALLEREQUISICION

Definition


CREATE TABLE DETALLEREQUISICION (
    ID_DETALLE_REQ CHAR (8) CHARACTER SET NONE NOT NULL COLLATE NONE,
    ARTICULO CHAR (8) CHARACTER SET NONE NOT NULL COLLATE NONE,
    CANTIDAD FLOAT NOT NULL,
    CODIGO_REQUISICION CHAR (8) CHARACTER SET NONE NOT NULL COLLATE NONE,
    ITEM_ENTREGADO BOOLEAN,
    ITEM_ANULADO BOOLEAN);

ALTER TABLE DETALLEREQUISICION ADD CONSTRAINT FK_DETALLEREQUISICION FOREIGN KEY (CODIGO_REQUISICION) REFERENCES REQUISICION (ID_REQUISICION);
ALTER TABLE DETALLEREQUISICION ADD  FOREIGN KEY (ARTICULO) REFERENCES INVENTARIO (ID_ARTICULO);
CREATE INDEX FK_DETALLEREQUISICION ON DETALLEREQUISICION (CODIGO_REQUISICION);

This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 09/06/2005 05:52 p.m.